|
220
|
How can I remove all the columns
excombobox1.Columns.Clear();
|
|
219
|
How can I remove a column
excombobox1.Columns.Remove("A");
|
|
482
|
How can I put icons/images into buttons
excombobox1.BeginUpdate();
excombobox1.SingleEdit = true;
excombobox1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
excombobox1.Columns.Add("");
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("C+B") as exontrol.EXCOMBOBOXLib.Column);
var_Column.AllowSizing = false;
var_Column.Width = 48;
var_Column.FormatColumn = "` <img>` + ( 1 + (1 index ``) mod 3 ) + `</img> `";
var_Column.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,true);
var_Column.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasButton,true);
var_Column.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellButtonAutoWidth,true);
var_Column.Position = 0;
excombobox1.DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines;
excombobox1.DefaultItemHeight = 20;
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Item 1");
var_Items.AddItem("Item 2");
var_Items.AddItem("Item 3");
var_Items.AddItem("Item 4");
var_Items.AddItem("Item 5");
var_Items.AddItem("Item 6");
var_Items.AddItem("Item 7");
var_Items.AddItem("Item 8");
excombobox1.EndUpdate();
|
|
205
|
How can I programmatically filter a column
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Filter") as exontrol.EXCOMBOBOXLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exNonBlanks;
excombobox1.Items.AddItem(null);
excombobox1.Items.AddItem("not empty");
excombobox1.ApplyFilter();
|
|
503
|
How can I programmatically clear the control's filter
// Click event - Occurs when the user presses and then releases the left mouse button over the list control.
private void excombobox1_Click(object sender)
{
excombobox1.ClearFilter();
}
//this.excombobox1.Click += new exontrol.EXCOMBOBOXLib.exg2antt.ClickEventHandler(this.excombobox1_Click);
excombobox1.BeginUpdate();
(excombobox1.Columns.Add("Item") as exontrol.EXCOMBOBOXLib.Column).DisplayFilterButton = true;
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Pos") as exontrol.EXCOMBOBOXLib.Column);
var_Column.AllowSizing = false;
var_Column.AllowSort = false;
var_Column.Width = 32;
var_Column.FormatColumn = "1 apos ``";
var_Column.Position = 0;
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Item A");
var_Items.AddItem("Item B");
var_Items.AddItem("Item C");
excombobox1.FilterBarPromptVisible = exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
excombobox1.FilterBarPromptPattern = "B";
excombobox1.EndUpdate();
|
|
91
|
How can I programmatically change the column where incremental searching is performed
excombobox1.Columns.Add("Column 1");
excombobox1.Columns.Add("Column 2");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_CellCaption(var_Items.AddItem("Item 1"),1,"SubItem 1");
excombobox1.SearchColumnIndex = 1;
|
|
488
|
How can I prevent showing the lines for the hierarchy while using the exMatchingItemsOnly option
excombobox1.BeginUpdate();
excombobox1.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot;
excombobox1.TreeColumnIndex = -1;
excombobox1.FilterInclude = exontrol.EXCOMBOBOXLib.FilterIncludeEnum.exMatchingItemsOnly;
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Column") as exontrol.EXCOMBOBOXLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter;
var_Column.Filter = "C1|C2";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("R1");
var_Items.InsertItem(h,null,"C1");
var_Items.InsertItem(h,null,"C2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("R2");
var_Items.InsertItem(h,null,"C1");
var_Items.InsertItem(h,null,"C2");
excombobox1.ApplyFilter();
excombobox1.EndUpdate();
|
|
315
|
How can I merge cells
excombobox1.MarkSearchColumn = false;
excombobox1.TreeColumnIndex = -1;
excombobox1.Columns.Add("C1");
excombobox1.Columns.Add("C2");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Cell 1");
var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.");
var_Items.set_CellSingleLine(h,1,exontrol.EXCOMBOBOXLib.CellSingleLineEnum.exCaptionWordWrap);
h = var_Items.AddItem("This is bit of text merges all cells in the item");
var_Items.set_ItemDivider(h,0);
var_Items.set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment);
|
|
316
|
How can I merge cells
excombobox1.DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exAllLines;
excombobox1.MarkSearchColumn = false;
excombobox1.Columns.Add("C1");
excombobox1.Columns.Add("C2");
excombobox1.Columns.Add("C3");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("this cell merges the first two columns");
var_Items.set_CellMerge(h,0,1);
h = var_Items.AddItem(null);
var_Items.set_CellCaption(h,1,"this cell merges the last two columns");
var_Items.set_CellMerge(h,1,2);
h = var_Items.AddItem("this cell merges the all three columns");
var_Items.set_CellMerge(h,0,1);
var_Items.set_CellMerge(h,0,2);
h = var_Items.AddItem("this draws a divider item");
var_Items.set_ItemDivider(h,0);
|
|
364
|
How can I mark the cells that has a specified type, ie strings only
excombobox1.ConditionalFormats.Add("type(%0) = 8",null).ForeColor = Color.FromArgb(255,0,0);
excombobox1.Columns.Add("");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,2);
var_Items.InsertItem(h,null,"Chld 3");
var_Items.set_ExpandItem(h,true);
|
|
467
|
How can I make bigger/enlarge the control's drop down button
excombobox1.BeginUpdate();
excombobox1.LabelHeight = 40;
excombobox1.ScrollWidth = 40;
excombobox1.EndUpdate();
|
|
254
|
How can I make an item unselectable, or not selectable
excombobox1.Columns.Add("Column");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("unselectable - you can't get selected");
var_Items.set_SelectableItem(h,false);
var_Items.AddItem("selectable");
|
|
7
|
How can I insert an icon to column's header
excombobox1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
(excombobox1.Columns.Add("ColumnName") as exontrol.EXCOMBOBOXLib.Column).HTMLCaption = "<b>HTML</b> Column <img>1</img> Icon";
|
|
6
|
How can I insert an icon to column's header
excombobox1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
(excombobox1.Columns.Add("ColumnName") as exontrol.EXCOMBOBOXLib.Column).HeaderImage = 1;
|
|
295
|
How can I insert a hyperlink or an anchor element
excombobox1.Columns.Add("Column");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_CellCaptionFormat(var_Items.AddItem("Just an <a1>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML);
exontrol.EXCOMBOBOXLib.Items var_Items1 = excombobox1.Items;
var_Items1.set_CellCaptionFormat(var_Items1.AddItem("Just another <a2>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML);
|
|
360
|
How can I highlight the cells or items that starts with a specified string
excombobox1.ConditionalFormats.Add("%0 startwith 'C'",null).Underline = true;
excombobox1.Columns.Add("");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"SChild 3");
var_Items.set_ExpandItem(h,true);
|
|
421
|
How can I highlight only parts of the cells
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("") as exontrol.EXCOMBOBOXLib.Column);
var_Column.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
11
|
How can I hide the searching column
excombobox1.MarkSearchColumn = false;
excombobox1.Columns.Add("Column 1");
excombobox1.Columns.Add("Column 2");
excombobox1.Items.AddItem(null);
|
|
126
|
How can I hide the locked / fixed items
excombobox1.ShowLockedItems = false;
excombobox1.Columns.Add("Column");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,1);
var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,0),0,"locked item");
var_Items.AddItem("un-locked item");
|
|
342
|
How can I hide the drop down buttons when the control loses the focus
excombobox1.HideDropDownButton = true;
excombobox1.IntegralHeight = true;
excombobox1.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot;
excombobox1.TreeColumnIndex = 1;
excombobox1.Columns.Add("Column 1");
excombobox1.Columns.Add("Column 2");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root 1.1");
var_Items.set_CellCaption(h,1,"Root 1.2");
var_Items.set_CellCaption(var_Items.InsertItem(h,null,"Child 1.1"),1,"Child 1.2");
var_Items.set_CellCaption(var_Items.InsertItem(h,null,"Child 2.1"),1,"Child 2.2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2.1");
var_Items.set_CellCaption(h,1,"Root 2.2");
var_Items.set_CellCaption(var_Items.InsertItem(h,null,"Child 1.1"),1,"Child 1.2");
|
|
253
|
How can I hide or show an item
excombobox1.Columns.Add("Column");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("hidden");
var_Items.set_ItemHeight(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.AddItem("visible");
|
|
120
|
How can I hide a column
(excombobox1.Columns.Add("Hidden") as exontrol.EXCOMBOBOXLib.Column).Visible = false;
excombobox1.Columns.Add("2");
excombobox1.Columns.Add("3");
excombobox1.Columns.Add("4");
excombobox1.Columns.Add("5");
|
|
461
|
How can I have a case-sensitive filter
excombobox1.BeginUpdate();
excombobox1.MarkSearchColumn = false;
exontrol.EXCOMBOBOXLib.Columns var_Columns = excombobox1.Columns;
exontrol.EXCOMBOBOXLib.Column var_Column = (var_Columns.Add("Car") as exontrol.EXCOMBOBOXLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilterDoCaseSensitive | exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter;
var_Column.Filter = "Mazda";
exontrol.EXCOMBOBOXLib.Column var_Column1 = (var_Columns.Add("Equipment") as exontrol.EXCOMBOBOXLib.Column);
var_Column1.DisplayFilterButton = true;
var_Column1.DisplayFilterPattern = false;
var_Column1.CustomFilter = "Air Bag||*Air Bag*|||Air condition||*Air condition*|||ABS||*ABS*|||ESP||*ESP*";
var_Column1.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilterDoCaseSensitive | exontrol.EXCOMBOBOXLib.FilterTypeEnum.exPattern;
var_Column1.Filter = "Air Bag";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag");
var_Items.set_CellCaption(var_Items.AddItem("Toyota"),1,"Air Bag,Air condition");
var_Items.set_CellCaption(var_Items.AddItem("Ford"),1,"Air condition");
var_Items.set_CellCaption(var_Items.AddItem("Nissan"),1,"Air Bag,ABS,ESP");
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag, ABS,ESP");
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"ABS,ESP");
excombobox1.ApplyFilter();
excombobox1.EndUpdate();
|
|
462
|
How can I have a case-insensitive filter (exFilterDoCaseSensitive flag is not set)
excombobox1.BeginUpdate();
excombobox1.MarkSearchColumn = false;
exontrol.EXCOMBOBOXLib.Columns var_Columns = excombobox1.Columns;
exontrol.EXCOMBOBOXLib.Column var_Column = (var_Columns.Add("Car") as exontrol.EXCOMBOBOXLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter;
var_Column.Filter = "MAZDA";
exontrol.EXCOMBOBOXLib.Column var_Column1 = (var_Columns.Add("Equipment") as exontrol.EXCOMBOBOXLib.Column);
var_Column1.DisplayFilterButton = true;
var_Column1.DisplayFilterPattern = false;
var_Column1.CustomFilter = "Air Bag||*Air Bag*|||Air condition||*Air condition*|||ABS||*ABS*|||ESP||*ESP*";
var_Column1.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exPattern;
var_Column1.Filter = "AIR BAG";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag");
var_Items.set_CellCaption(var_Items.AddItem("Toyota"),1,"Air Bag,Air condition");
var_Items.set_CellCaption(var_Items.AddItem("Ford"),1,"Air condition");
var_Items.set_CellCaption(var_Items.AddItem("Nissan"),1,"Air Bag,ABS,ESP");
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag, ABS,ESP");
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"ABS,ESP");
excombobox1.ApplyFilter();
excombobox1.EndUpdate();
|
|
29
|
How can I get underlined only a portion of column's header
(excombobox1.Columns.Add("Column 1") as exontrol.EXCOMBOBOXLib.Column).HTMLCaption = "<u>Col</u>umn 1";
|
|
218
|
How can I get the number or the count of columns
int var_Count = excombobox1.Columns.Count;
|
|
519
|
How can I get the number of results/items being shown in the control's filter bar (sample 4)
excombobox1.BeginUpdate();
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Item") as exontrol.EXCOMBOBOXLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.FilterList = exontrol.EXCOMBOBOXLib.FilterListEnum.exShowExclude | exontrol.EXCOMBOBOXLib.FilterListEnum.exShowFocusItem | exontrol.EXCOMBOBOXLib.FilterListEnum.exShowCheckBox | exontrol.EXCOMBOBOXLib.FilterListEnum.exSortItemsAsc;
exontrol.EXCOMBOBOXLib.Column var_Column1 = (excombobox1.Columns.Add("Pos") as exontrol.EXCOMBOBOXLib.Column);
var_Column1.AllowSizing = false;
var_Column1.AllowSort = false;
var_Column1.Width = 32;
var_Column1.FormatColumn = "1 apos ``";
var_Column1.Position = 0;
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Item A");
var_Items.AddItem("Item B");
var_Items.AddItem("Item C");
excombobox1.FilterBarFont = (excombobox1.Font as stdole.IFontDisp);
excombobox1.FilterBarPrompt = excombobox1.FormatABC("`<b>` + value",excombobox1.FilterBarPrompt,null,null).ToString();
excombobox1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount " +
"+ 1) + ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )";
excombobox1.FilterBarPromptVisible = exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarCompact | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarVisible | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
excombobox1.EndUpdate();
|
|
518
|
How can I get the number of results being shown in the control's filter bar (sample 3)
excombobox1.BeginUpdate();
(excombobox1.Columns.Add("Item") as exontrol.EXCOMBOBOXLib.Column).DisplayFilterButton = true;
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Pos") as exontrol.EXCOMBOBOXLib.Column);
var_Column.AllowSizing = false;
var_Column.AllowSort = false;
var_Column.Width = 32;
var_Column.FormatColumn = "1 apos ``";
var_Column.Position = 0;
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Item A");
var_Items.AddItem("Item B");
var_Items.AddItem("Item C");
excombobox1.FilterBarFont = (excombobox1.Font as stdole.IFontDisp);
excombobox1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount " +
"+ 1) + ` result(s)` ) : ``)";
excombobox1.FilterBarPromptVisible = exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarCompact | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarVisible | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
exontrol.EXCOMBOBOXLib.Column var_Column1 = excombobox1.Columns[0];
var_Column1.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter;
var_Column1.Filter = "Item A|Item B";
excombobox1.ApplyFilter();
excombobox1.EndUpdate();
|
|
517
|
How can I get the number of results being shown in the control's filter bar (sample 2, compact)
excombobox1.BeginUpdate();
(excombobox1.Columns.Add("Item") as exontrol.EXCOMBOBOXLib.Column).DisplayFilterButton = true;
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Pos") as exontrol.EXCOMBOBOXLib.Column);
var_Column.AllowSizing = false;
var_Column.AllowSort = false;
var_Column.Width = 32;
var_Column.FormatColumn = "1 apos ``";
var_Column.Position = 0;
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Item A");
var_Items.AddItem("Item B");
var_Items.AddItem("Item C");
excombobox1.FilterBarFont = (excombobox1.Font as stdole.IFontDisp);
excombobox1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? `<off -4> ` + abs(matchitemcount + 1) + ` result(s)` : ``)";
excombobox1.FilterBarPromptVisible = exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarCompact | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarSingleLine | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarVisible | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
exontrol.EXCOMBOBOXLib.Column var_Column1 = excombobox1.Columns[0];
var_Column1.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter;
var_Column1.Filter = "Item A|Item B";
excombobox1.ApplyFilter();
excombobox1.EndUpdate();
|
|
516
|
How can I get the number of results being shown in the control's filter bar (sample 1)
excombobox1.BeginUpdate();
(excombobox1.Columns.Add("Item") as exontrol.EXCOMBOBOXLib.Column).DisplayFilterButton = true;
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Pos") as exontrol.EXCOMBOBOXLib.Column);
var_Column.AllowSizing = false;
var_Column.AllowSort = false;
var_Column.Width = 32;
var_Column.FormatColumn = "1 apos ``";
var_Column.Position = 0;
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Item A");
var_Items.AddItem("Item B");
var_Items.AddItem("Item C");
excombobox1.FilterBarFont = (excombobox1.Font as stdole.IFontDisp);
excombobox1.FilterBarCaption = "`<b>` + value + `</b><r><fgcolor=808080>` + ( matchitemcount < 0 ? abs(matchitemcount + 1) + ` result(s)` : ``)";
excombobox1.FilterBarPromptVisible = exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarVisible | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
exontrol.EXCOMBOBOXLib.Column var_Column1 = excombobox1.Columns[0];
var_Column1.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter;
var_Column1.Filter = "Item A|Item B";
excombobox1.ApplyFilter();
excombobox1.EndUpdate();
|
|
504
|
How can I get the number of results after a filter is applied
// Click event - Occurs when the user presses and then releases the left mouse button over the list control.
private void excombobox1_Click(object sender)
{
excombobox1.ClearFilter();
}
//this.excombobox1.Click += new exontrol.EXCOMBOBOXLib.exg2antt.ClickEventHandler(this.excombobox1_Click);
// FilterChange event - Occurs when filter was changed.
private void excombobox1_FilterChange(object sender)
{
System.Diagnostics.Debug.Print( "Items.MatchItemCount" );
System.Diagnostics.Debug.Print( excombobox1.Items.MatchItemCount.ToString() );
System.Diagnostics.Debug.Print( excombobox1.FormatABC("value < 0 ? `filter applied: ` + abs(value + 1) + ` result(s)` : `no filter`",excombobox1.Items.MatchItemCount,null,null).ToString() );
}
//this.excombobox1.FilterChange += new exontrol.EXCOMBOBOXLib.exg2antt.FilterChangeEventHandler(this.excombobox1_FilterChange);
excombobox1.BeginUpdate();
(excombobox1.Columns.Add("Item") as exontrol.EXCOMBOBOXLib.Column).DisplayFilterButton = true;
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Pos") as exontrol.EXCOMBOBOXLib.Column);
var_Column.AllowSizing = false;
var_Column.AllowSort = false;
var_Column.Width = 32;
var_Column.FormatColumn = "1 apos ``";
var_Column.Position = 0;
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Item A");
var_Items.AddItem("Item B");
var_Items.AddItem("Item C");
excombobox1.FilterBarPromptVisible = exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
excombobox1.FilterBarPromptPattern = "Item";
excombobox1.EndUpdate();
|
|
420
|
How can I get the number of occurrences of a specified string in the cell
excombobox1.Columns.Add("");
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("occurrences") as exontrol.EXCOMBOBOXLib.Column);
var_Column.ComputedField = "lower(%0) count 'o'";
var_Column.FormatColumn = "'contains ' + value + ' of \\'o\\' chars'";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1 oooof the root");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
399
|
How can I get the number of occurrences of a specified string in the cell
excombobox1.Columns.Add("");
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("occurrences") as exontrol.EXCOMBOBOXLib.Column);
var_Column.ComputedField = "lower(%0) count 'o'";
var_Column.FormatColumn = "'contains ' + value + ' of \\'o\\' chars'";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1 oooof the root");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
|
|
277
|
How can I get the handle of an item based on the handle of the cell
excombobox1.Columns.Add("Default");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
var_Items.set_ItemBold(var_Items.get_CellItem(var_Items.get_ItemCell(h,0)),true);
|
|
222
|
How can I get the columns as they are shown in the control's sortbar
Object var_Object = (excombobox1.Columns.get_ItemBySortPosition(0) as Object);
|
|
386
|
How can I get second part of the date
excombobox1.Columns.Add("Date");
(excombobox1.Columns.Add("Second") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "sec(date(%0))";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:10:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:22",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:01",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:11:59",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
65
|
How can I get ride/hide of the "Filter For" field
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Column") as exontrol.EXCOMBOBOXLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
|
|
368
|
How can I get or display the integer part of the cell
excombobox1.Columns.Add("Number");
(excombobox1.Columns.Add("Int") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "int(%0)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("-1.98");
var_Items.AddItem("0.99");
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
|
|
379
|
How can I get only the year part from a date expression
excombobox1.Columns.Add("Date");
(excombobox1.Columns.Add("Year") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "year(%0)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
385
|
How can I get minute part of the date
excombobox1.Columns.Add("Date");
(excombobox1.Columns.Add("Minute") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "min(date(%0))";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:10:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:11:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
309
|
How can I fix or lock items
excombobox1.Columns.Add("Default");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,1);
var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,0),0,"This is a locked item, fixed to the top side of the control.");
var_Items.set_ItemBackColor(var_Items.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,0),Color.FromArgb(196,196,186));
var_Items.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,2);
var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,0),0,"This is a locked item, fixed to the top side of the control.");
var_Items.set_ItemBackColor(var_Items.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,0),Color.FromArgb(196,196,186));
var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,1),0,"This is a locked item, fixed to the top side of the control.");
var_Items.set_ItemBackColor(var_Items.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,1),Color.FromArgb(186,186,186));
|
|
307
|
How can I fix or lock an item on the top of the control
excombobox1.Columns.Add("Default");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,1);
var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,0),0,"This is a locked item, fixed to the top side of the control.");
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
|
|
308
|
How can I fix or lock an item on the bottom side of the control
excombobox1.Columns.Add("Default");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,1);
var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,0),0,"This is a locked item, fixed to the bottom side of the control.");
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
|
|
292
|
How can I find the cell being clicked in a radio group
excombobox1.MarkSearchColumn = false;
excombobox1.SelBackColor = Color.FromArgb(255,255,128);
excombobox1.SelForeColor = Color.FromArgb(0,0,0);
excombobox1.Columns.Add("C1");
excombobox1.Columns.Add("C2");
excombobox1.Columns.Add("C3");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Cell 1");
var_Items.set_CellCaption(h,1,"Radio 1");
var_Items.set_CellHasRadioButton(h,1,true);
var_Items.set_CellRadioGroup(h,1,1234);
var_Items.set_CellCaption(h,2,"Radio 2");
var_Items.set_CellHasRadioButton(h,2,true);
var_Items.set_CellRadioGroup(h,2,1234);
var_Items.set_CellState(h,1,1);
var_Items.set_CellBold(null,var_Items.get_CellChecked(1234),true);
|
|
489
|
How can I find if there is any filter applied to the control
// FilterChange event - Occurs when filter was changed.
private void excombobox1_FilterChange(object sender)
{
System.Diagnostics.Debug.Print( "If negative, the filter is present, else not" );
System.Diagnostics.Debug.Print( excombobox1.Items.VisibleItemCount.ToString() );
}
//this.excombobox1.FilterChange += new exontrol.EXCOMBOBOXLib.exg2antt.FilterChangeEventHandler(this.excombobox1_FilterChange);
excombobox1.BeginUpdate();
excombobox1.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot;
excombobox1.TreeColumnIndex = -1;
excombobox1.FilterInclude = exontrol.EXCOMBOBOXLib.FilterIncludeEnum.exMatchingItemsOnly;
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Column") as exontrol.EXCOMBOBOXLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter;
var_Column.Filter = "C1";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("R1");
var_Items.InsertItem(h,null,"C1");
var_Items.InsertItem(h,null,"C2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("R2");
var_Items.InsertItem(h,null,"C1");
var_Items.InsertItem(h,null,"C2");
excombobox1.ApplyFilter();
excombobox1.EndUpdate();
|
|
497
|
How can I find if the control is running in DPI mode
System.Diagnostics.Debug.Print( excombobox1.FormatABC("dpi = 1 ? `normal/stretch mode` : `dpi mode`",null,null,null).ToString() );
|
|
44
|
How can I filter the items that are between an interval/range of dates
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Column") as exontrol.EXCOMBOBOXLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterDate = true;
excombobox1.ApplyFilter();
|
|
412
|
How can I filter programatically using more columns
excombobox1.BeginUpdate();
excombobox1.MarkSearchColumn = false;
exontrol.EXCOMBOBOXLib.Columns var_Columns = excombobox1.Columns;
var_Columns.Add("Car");
var_Columns.Add("Equipment");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag");
var_Items.set_CellCaption(var_Items.AddItem("Toyota"),1,"Air Bag,Air condition");
var_Items.set_CellCaption(var_Items.AddItem("Ford"),1,"Air condition");
var_Items.set_CellCaption(var_Items.AddItem("Nissan"),1,"Air Bag,ABS,ESP");
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag, ABS,ESP");
var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"ABS,ESP");
exontrol.EXCOMBOBOXLib.Column var_Column = excombobox1.Columns["Car"];
var_Column.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter;
var_Column.Filter = "Mazda";
exontrol.EXCOMBOBOXLib.Column var_Column1 = excombobox1.Columns["Equipment"];
var_Column1.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exPattern;
var_Column1.Filter = "*ABS*|*ESP*";
excombobox1.ApplyFilter();
excombobox1.EndUpdate();
|
|
426
|
How can I expand all items
excombobox1.BeginUpdate();
excombobox1.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot;
excombobox1.Columns.Add("Items");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(0,true);
excombobox1.EndUpdate();
|
|
341
|
How can I ensure that the drop down portions doesn't show partial items
excombobox1.IntegralHeight = true;
excombobox1.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot;
excombobox1.TreeColumnIndex = 1;
excombobox1.Columns.Add("Column 1");
excombobox1.Columns.Add("Column 2");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root 1.1");
var_Items.set_CellCaption(h,1,"Root 1.2");
var_Items.set_CellCaption(var_Items.InsertItem(h,null,"Child 1.1"),1,"Child 1.2");
var_Items.set_CellCaption(var_Items.InsertItem(h,null,"Child 2.1"),1,"Child 2.2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2.1");
var_Items.set_CellCaption(h,1,"Root 2.2");
var_Items.set_CellCaption(var_Items.InsertItem(h,null,"Child 1.1"),1,"Child 1.2");
|
|
580
|
How can I enable the clear-button (visible only if required)
excombobox1.BeginUpdate();
excombobox1.Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList;
excombobox1.HeaderVisible = false;
excombobox1.IntegralHeight = true;
excombobox1.ShowClearButton = 1;
excombobox1.Columns.Add("Column");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Zero");
var_Items.AddItem("One");
var_Items.AddItem("Two");
excombobox1.set_Select(0,"Zero");
excombobox1.EndUpdate();
|
|
584
|
How can I enable the clear-button (visible only if required and focused)
excombobox1.BeginUpdate();
excombobox1.Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList;
excombobox1.HeaderVisible = false;
excombobox1.IntegralHeight = true;
excombobox1.ShowClearButton = 3;
excombobox1.Columns.Add("Column");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Zero");
var_Items.AddItem("One");
var_Items.AddItem("Two");
excombobox1.set_Select(0,"Zero");
excombobox1.EndUpdate();
|
|
583
|
How can I enable the clear-button (visible only if focused)
excombobox1.BeginUpdate();
excombobox1.Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList;
excombobox1.HeaderVisible = false;
excombobox1.IntegralHeight = true;
excombobox1.ShowClearButton = 2;
excombobox1.Columns.Add("Column");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Zero");
var_Items.AddItem("One");
var_Items.AddItem("Two");
excombobox1.set_Select(0,"Zero");
excombobox1.EndUpdate();
|
|
581
|
How can I enable the clear-button (always visible)
excombobox1.BeginUpdate();
excombobox1.Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList;
excombobox1.HeaderVisible = false;
excombobox1.IntegralHeight = true;
excombobox1.ShowClearButton = -1;
excombobox1.Columns.Add("Column");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Zero");
var_Items.AddItem("One");
var_Items.AddItem("Two");
excombobox1.set_Select(0,"Zero");
excombobox1.EndUpdate();
|
|
18
|
How can I draw grid lines only for visible items
excombobox1.MarkSearchColumn = false;
excombobox1.DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exRowLines;
excombobox1.Columns.Add("Column 1");
excombobox1.Columns.Add("Column 2");
excombobox1.Items.AddItem(0);
excombobox1.Items.AddItem(1);
excombobox1.Items.AddItem(2);
|
|
554
|
How can I display UNICODE characters
excombobox1.BeginUpdate();
stdole.IFontDisp var_StdFont = excombobox1.Font;
var_StdFont.Name = "Arial Unicode";
var_StdFont.Size = 22;
excombobox1.HeaderVisible = false;
excombobox1.DefaultItemHeight = 48;
(excombobox1.Columns.Add("") as exontrol.EXCOMBOBOXLib.Column).set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Ӓӓ");
var_Items.AddItem("ᦜᦝ;ᦞ");
var_Items.AddItem("ɮɭ;ɯ");
var_Items.AddItem("勳勴勵勶");
var_Items.set_FormatCell(var_Items.AddItem(excombobox1.Version),0,"(value lfind `UNICODE`) < 0 ? `<fgcolor=FF0000><b>!UNICODE!</b> version</fgcolor> required: ` + value : `` ");
excombobox1.EndUpdate();
|
|
415
|
How can I display true or false instead 0 and -1
(excombobox1.Columns.Add("Boolean") as exontrol.EXCOMBOBOXLib.Column).FormatColumn = "value != 0 ? 'true' : 'false'";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(true);
var_Items.AddItem(false);
var_Items.AddItem(true);
var_Items.AddItem(0);
var_Items.AddItem(1);
|
|
393
|
How can I display true or false instead 0 and -1
(excombobox1.Columns.Add("Boolean") as exontrol.EXCOMBOBOXLib.Column).FormatColumn = "value != 0 ? 'true' : 'false'";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(true);
var_Items.AddItem(false);
var_Items.AddItem(true);
var_Items.AddItem(0);
var_Items.AddItem(1);
|
|
374
|
How can I display the time only of a date expression
excombobox1.Columns.Add("Date");
(excombobox1.Columns.Add("Time") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "'time is:' + time(date(%0))";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
387
|
How can I display the number of days between two dates
excombobox1.Columns.Add("Start");
excombobox1.Columns.Add("End");
(excombobox1.Columns.Add("Duration") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "(date(%1)-date(%0)) + ' days'";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("2/22/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
390
|
How can I display the currency only for not empty cells
excombobox1.Columns.Add("Number");
(excombobox1.Columns.Add("Currency") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "len(%0) ? currency(dbl(%0)) : ''";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
var_Items.AddItem("0");
var_Items.set_ItemBackColor(var_Items.AddItem(null),Color.FromArgb(255,128,128));
var_Items.AddItem("10000.99");
|
|
505
|
How can I display the control's filter on a single line (prompt-combined)
excombobox1.BeginUpdate();
(excombobox1.Columns.Add("Item") as exontrol.EXCOMBOBOXLib.Column).DisplayFilterButton = true;
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Pos") as exontrol.EXCOMBOBOXLib.Column);
var_Column.AllowSizing = false;
var_Column.AllowSort = false;
var_Column.Width = 32;
var_Column.FormatColumn = "1 apos ``";
var_Column.Position = 0;
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Item A");
var_Items.AddItem("Item B");
var_Items.AddItem("Item C");
excombobox1.FilterBarCaption = "`<r>` + value";
excombobox1.FilterBarPromptVisible = exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarCompact | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarSingleLine | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarVisible | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
exontrol.EXCOMBOBOXLib.Column var_Column1 = excombobox1.Columns[0];
var_Column1.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter;
var_Column1.Filter = "Item A|Item B";
excombobox1.ApplyFilter();
excombobox1.EndUpdate();
|
|
506
|
How can I display the control's filter on a single line
excombobox1.BeginUpdate();
(excombobox1.Columns.Add("Item") as exontrol.EXCOMBOBOXLib.Column).DisplayFilterButton = true;
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Pos") as exontrol.EXCOMBOBOXLib.Column);
var_Column.AllowSizing = false;
var_Column.AllowSort = false;
var_Column.Width = 32;
var_Column.FormatColumn = "1 apos ``";
var_Column.Position = 0;
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Item A");
var_Items.AddItem("Item B");
var_Items.AddItem("Item C");
excombobox1.FilterBarCaption = "len(value) ? `filter for: <fgcolor 808080>` + value : `<fgcolor 808080>no filter`";
excombobox1.FilterBarPromptVisible = exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarSingleLine | exontrol.EXCOMBOBOXLib.FilterBarVisibleEnum.exFilterBarVisible;
exontrol.EXCOMBOBOXLib.Column var_Column1 = excombobox1.Columns[0];
var_Column1.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exFilter;
var_Column1.Filter = "Item A|Item B";
excombobox1.ApplyFilter();
excombobox1.EndUpdate();
|
|
400
|
How can I display the column using currency format and enlarge the font for certain values
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Currency") as exontrol.EXCOMBOBOXLib.Column);
var_Column.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
var_Items.AddItem("9.94");
var_Items.AddItem("11.94");
var_Items.AddItem("1000");
|
|
422
|
How can I display the column using currency format and enlarge the font for certain values
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Currency") as exontrol.EXCOMBOBOXLib.Column);
var_Column.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
var_Items.AddItem("9.94");
var_Items.AddItem("11.94");
var_Items.AddItem("1000");
|
|
391
|
How can I display the column using currency
(excombobox1.Columns.Add("Currency") as exontrol.EXCOMBOBOXLib.Column).FormatColumn = "currency(dbl(value))";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
var_Items.AddItem("0");
var_Items.AddItem(5);
var_Items.AddItem("10000.99");
|
|
413
|
How can I display the column using currency
(excombobox1.Columns.Add("Currency") as exontrol.EXCOMBOBOXLib.Column).FormatColumn = "currency(dbl(value))";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("1.23");
var_Items.AddItem("2.34");
var_Items.AddItem("0");
var_Items.AddItem(5);
var_Items.AddItem("10000.99");
|
|
356
|
How can I display the column's header using multiple lines
excombobox1.HeaderHeight = 128;
excombobox1.HeaderSingleLine = false;
(excombobox1.Columns.Add("This is just a column that should break the header.") as exontrol.EXCOMBOBOXLib.Column).Width = 32;
excombobox1.Columns.Add("This is just another column that should break the header.");
|
|
56
|
How can I display the column's filter
(excombobox1.Columns.Add("") as exontrol.EXCOMBOBOXLib.Column).DisplayFilterButton = true;
|
|
416
|
How can I display only the right part of the cell
excombobox1.Columns.Add("");
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Right") as exontrol.EXCOMBOBOXLib.Column);
var_Column.ComputedField = "%0 right 2";
var_Column.FormatColumn = "'\"' + value + '\"'";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"SChild 3");
var_Items.set_ExpandItem(h,true);
|
|
395
|
How can I display only the right part of the cell
excombobox1.Columns.Add("");
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Right") as exontrol.EXCOMBOBOXLib.Column);
var_Column.ComputedField = "%0 right 2";
var_Column.FormatColumn = "'\"' + value + '\"'";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"SChild 3");
var_Items.set_ExpandItem(h,true);
|
|
380
|
How can I display only the month of the date
excombobox1.Columns.Add("Date");
(excombobox1.Columns.Add("Month") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "month(%0)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
394
|
How can I display only the left part of the cell
excombobox1.Columns.Add("");
(excombobox1.Columns.Add("Left") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "%0 left 2";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Root");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"SChild 3");
var_Items.set_ExpandItem(h,true);
|
|
381
|
How can I display only the day of the date
excombobox1.Columns.Add("Date");
(excombobox1.Columns.Add("Day") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "day(%0)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
439
|
How can I display numbers with 2 digits in each group
excombobox1.BeginUpdate();
(excombobox1.Columns.Add("Def") as exontrol.EXCOMBOBOXLib.Column).set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem(100000.27);
var_Items.set_FormatCell(h,0,"(value format '') + ' <fgcolor=808080>(default)'");
h = var_Items.AddItem(100000.27);
var_Items.set_FormatCell(h,0,"(value format '||2') + ' <fgcolor=808080>(grouping by 2 digits)'");
excombobox1.EndUpdate();
|
|
367
|
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
(excombobox1.Columns.Add("") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "proper(%0)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("root");
var_Items.InsertItem(h,null,"child child");
var_Items.InsertItem(h,null,"child child");
var_Items.InsertItem(h,null,"child child");
var_Items.set_ExpandItem(h,true);
|
|
168
|
How can I display my text on the scroll bar, using a different font
excombobox1.set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exThumbPart,"This is <s><font Tahoma;12> just </font></s> text");
excombobox1.ColumnAutoResize = false;
excombobox1.ScrollHeight = 20;
(excombobox1.Columns.Add("C1") as exontrol.EXCOMBOBOXLib.Column).Width = 256;
(excombobox1.Columns.Add("C2") as exontrol.EXCOMBOBOXLib.Column).Width = 256;
(excombobox1.Columns.Add("C3") as exontrol.EXCOMBOBOXLib.Column).Width = 256;
|
|
167
|
How can I display my text on the scroll bar, using a different font
excombobox1.set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exThumbPart,"This is just a text");
excombobox1.get_ScrollFont(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll).Size = 12;
excombobox1.ColumnAutoResize = false;
excombobox1.ScrollHeight = 20;
(excombobox1.Columns.Add("C1") as exontrol.EXCOMBOBOXLib.Column).Width = 256;
(excombobox1.Columns.Add("C2") as exontrol.EXCOMBOBOXLib.Column).Width = 256;
(excombobox1.Columns.Add("C3") as exontrol.EXCOMBOBOXLib.Column).Width = 256;
|
|
166
|
How can I display my text on the scroll bar
excombobox1.set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exThumbPart,"this is just a text");
excombobox1.ColumnAutoResize = false;
(excombobox1.Columns.Add("C1") as exontrol.EXCOMBOBOXLib.Column).Width = 256;
(excombobox1.Columns.Add("C2") as exontrol.EXCOMBOBOXLib.Column).Width = 256;
(excombobox1.Columns.Add("C3") as exontrol.EXCOMBOBOXLib.Column).Width = 256;
|
|
438
|
How can I display my numbers using a different decimal separator
excombobox1.BeginUpdate();
(excombobox1.Columns.Add("Def") as exontrol.EXCOMBOBOXLib.Column).set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem(100.27);
var_Items.set_FormatCell(h,0,"(value format '') + ' <fgcolor=808080>(default)'");
h = var_Items.AddItem(100.27);
var_Items.set_FormatCell(h,0,"(value format '|;') + ' <fgcolor=808080>(decimal separator is <b>;</b>)'");
excombobox1.EndUpdate();
|
|
414
|
How can I display icons or images instead numbers
excombobox1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Icons") as exontrol.EXCOMBOBOXLib.Column);
var_Column.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "'The cell displays the icon <img>'+value+'</img> instead ' + value";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(1);
var_Items.AddItem(2);
var_Items.AddItem(3);
|
|
392
|
How can I display icons or images instead numbers
excombobox1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Icons") as exontrol.EXCOMBOBOXLib.Column);
var_Column.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "'The cell displays the icon <img>'+value+'</img> instead ' + value";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(1);
var_Items.AddItem(2);
var_Items.AddItem(3);
|
|
397
|
How can I display dates in short format
(excombobox1.Columns.Add("Date") as exontrol.EXCOMBOBOXLib.Column).FormatColumn = "shortdate(value)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
375
|
How can I display dates in short format
excombobox1.Columns.Add("Date");
(excombobox1.Columns.Add("ShortFormat") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "shortdate(%0)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
418
|
How can I display dates in short format
(excombobox1.Columns.Add("Date") as exontrol.EXCOMBOBOXLib.Column).FormatColumn = "shortdate(value)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
419
|
How can I display dates in my format
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Date") as exontrol.EXCOMBOBOXLib.Column);
var_Column.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/21/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/24/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
398
|
How can I display dates in my format
exontrol.EXCOMBOBOXLib.Column var_Column = (excombobox1.Columns.Add("Date") as exontrol.EXCOMBOBOXLib.Column);
var_Column.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
var_Column.FormatColumn = "'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/21/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/22/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/24/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
417
|
How can I display dates in long format
(excombobox1.Columns.Add("Date") as exontrol.EXCOMBOBOXLib.Column).FormatColumn = "longdate(value)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
396
|
How can I display dates in long format
(excombobox1.Columns.Add("Date") as exontrol.EXCOMBOBOXLib.Column).FormatColumn = "longdate(value)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
376
|
How can I display dates in long format
excombobox1.Columns.Add("Date");
(excombobox1.Columns.Add("LongFormat") as exontrol.EXCOMBOBOXLib.Column).ComputedField = "longdate(%0)";
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
var_Items.AddItem(Convert.ToDateTime("4/4/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
|
|
271
|
How can I display an item or a cell on multiple lines
excombobox1.ScrollBySingleLine = true;
excombobox1.Columns.Add("C1");
excombobox1.Columns.Add("C2");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Cell 1");
var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines");
var_Items.set_CellSingleLine(h,1,exontrol.EXCOMBOBOXLib.CellSingleLineEnum.exCaptionWordWrap);
|
|
198
|
How can I display all cells using multiple lines
(excombobox1.Columns.Add("MultipleLine") as exontrol.EXCOMBOBOXLib.Column).set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine,false);
(excombobox1.Columns.Add("SingleLine") as exontrol.EXCOMBOBOXLib.Column).set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine,true);
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_CellCaption(var_Items.AddItem("This is a bit of long text that should break the line"),1,"this is a bit of long text that's displayed on a single line");
|
|
199
|
How can I display all cells using HTML format
(excombobox1.Columns.Add("HTML") as exontrol.EXCOMBOBOXLib.Column).set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
excombobox1.Items.AddItem("<font ;12>T</font>his <b>is</b> an <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>.");
|
|
190
|
How can I display a tooltip when the cursor hovers the column
(excombobox1.Columns.Add("tooltip") as exontrol.EXCOMBOBOXLib.Column).ToolTip = "This is a bit of text that is shown when user hovers the column.";
|
|
159
|
How can I display a multiple pictures to a cell or item
excombobox1.DefaultItemHeight = 48;
excombobox1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
excombobox1.set_HTMLPicture("pic2","c:\\exontrol\\images\\auction.gif");
excombobox1.Columns.Add("C1");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_CellCaptionFormat(var_Items.AddItem("<img>pic1</img> Text <img>pic2</img> another text ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML);
|
|
406
|
How can I display a filter field in the bottom part of the drop down portion
excombobox1.BeginUpdate();
excombobox1.FilterForVisible = true;
excombobox1.IntegralHeight = true;
excombobox1.Columns.Add("Default");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("Item 1");
var_Items.AddItem("Item 2");
var_Items.AddItem("Item 3");
var_Items.AddItem("Item 4");
var_Items.AddItem("Item 5");
excombobox1.EndUpdate();
|
|
310
|
How can I display a divider item, merging all cells
excombobox1.MarkSearchColumn = false;
excombobox1.TreeColumnIndex = -1;
excombobox1.Columns.Add("C1");
excombobox1.Columns.Add("C2");
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
int h = var_Items.AddItem("Cell 1");
var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.");
var_Items.set_CellSingleLine(h,1,exontrol.EXCOMBOBOXLib.CellSingleLineEnum.exCaptionWordWrap);
h = var_Items.AddItem("This is bit of text that's displayed on the entire item, divider.");
var_Items.set_ItemDivider(h,0);
var_Items.set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment);
|
|
485
|
How can I display a different column, on the control's label (method 2)
excombobox1.BeginUpdate();
excombobox1.Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList;
excombobox1.SingleEdit = true;
excombobox1.LabelColumnIndex = 1;
excombobox1.DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines;
(excombobox1.Columns.Add("Column 1") as exontrol.EXCOMBOBOXLib.Column).set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
(excombobox1.Columns.Add("Column 2") as exontrol.EXCOMBOBOXLib.Column).set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_CellCaption(var_Items.AddItem("Item 1 on <b>Column 1"),1,"Item 1 on <b>Column 2");
var_Items.set_CellCaption(var_Items.AddItem("Item 2 on <b>Column 1"),1,"Item 2 on <b>Column 2");
var_Items.set_CellCaption(var_Items.AddItem("Item 3 on <b>Column 1"),1,"Item 3 on <b>Column 2");
var_Items.set_SelectItem(var_Items.FirstVisibleItem,true);
excombobox1.EndUpdate();
|
|
484
|
How can I display a different column, on the control's label (method 1)
excombobox1.BeginUpdate();
excombobox1.Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList;
excombobox1.SingleEdit = true;
excombobox1.SearchColumnIndex = 1;
excombobox1.DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines;
(excombobox1.Columns.Add("Column 1") as exontrol.EXCOMBOBOXLib.Column).set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
(excombobox1.Columns.Add("Column 2") as exontrol.EXCOMBOBOXLib.Column).set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1);
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.set_CellCaption(var_Items.AddItem("Item 1 on <b>Column 1"),1,"Item 1 on <b>Column 2");
var_Items.set_CellCaption(var_Items.AddItem("Item 2 on <b>Column 1"),1,"Item 2 on <b>Column 2");
var_Items.set_CellCaption(var_Items.AddItem("Item 3 on <b>Column 1"),1,"Item 3 on <b>Column 2");
var_Items.set_SelectItem(var_Items.FirstVisibleItem,true);
excombobox1.EndUpdate();
|
|
410
|
How can I display a different caption in the label area, when I click the cell's check box
// CellStateChanged event - Fired after cell's state has been changed.
private void excombobox1_CellStateChanged(object sender, exontrol.EXCOMBOBOXLib.HCELL Cell)
{
excombobox1.LabelText = Cell.ToString();
System.Diagnostics.Debug.Print( excombobox1.Items.get_CellCaption(0,Cell).ToString() );
System.Diagnostics.Debug.Print( excombobox1.Items.get_CellState(0,Cell).ToString() );
}
//this.excombobox1.CellStateChanged += new exontrol.EXCOMBOBOXLib.exg2antt.CellStateChangedEventHandler(this.excombobox1_CellStateChanged);
excombobox1.BeginUpdate();
excombobox1.Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList;
excombobox1.IntegralHeight = true;
excombobox1.HeaderVisible = false;
excombobox1.SingleEdit = true;
excombobox1.SearchColumnIndex = -1;
excombobox1.AdjustSearchColumn = false;
(excombobox1.Columns.Add("Language") as exontrol.EXCOMBOBOXLib.Column).set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXCOMBOBOXLib.Items var_Items = excombobox1.Items;
var_Items.AddItem("English");
var_Items.AddItem("Hebrew");
var_Items.AddItem("Spanish");
excombobox1.LabelText = " <b>custom</b> text ";
excombobox1.EndUpdate();
|